SQL Interview Questions and Answers
Test your skills through the online practice test: SQL Quiz Online Practice Test
Ques 16. What is the first work of Client process ?
A client process at first establishes connection with the Server.
Is it helpful?
Add Comment
View Comments
Ques 17. What are the responsibilities of a Server ?
1. Manage resources optimally across multiple clients.
2. Controlling database access and security.
3. Protecting the database and recovering it from crashes.
4. Enforcing integrity rules globally.
Is it helpful?
Add Comment
View Comments
Ques 18. In a Client/Server context, what does API (Application Programming Interface) refer to ?
An API, in a Client/Server context, is a specification of a set of functions for communication between the client and the server.
Is it helpful?
Add Comment
View Comments
Ques 19. Give some examples of standard API??
Open Database Connectivity (ODBC),
Integrated Database Application Programming Interface (IDAPI),
XOpen
SQL/CLI
Is it helpful?
Add Comment
View Comments
Ques 20. What is the main advantage of developing an application using an API ?
The application can be connected to any back end server that is supported by the API.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: